package com.zzlzd.drp.domain;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @author ceshi
 * @Title:
 * @Package
 * @Description:
 * @date 2021-3-1622:09
 */
public interface SwiperRep extends JpaRepository<SwiperDto,Integer> {

    @Query(nativeQuery=true, value=" SELECT * FROM swiper WHERE status = 0 AND type =0 order by sort")
    public List<SwiperDto> findData();


    @Query(nativeQuery=true, value=" SELECT * FROM swiper WHERE status = 0 AND type =1 order by sort")
    public List<SwiperDto> findWenZhang();
}
